spc_tbl_ [3.818 × 92] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
$ id : num [1:3818] 241032 953595 3308979 7421966 278830 ...
$ listing_url : chr [1:3818] "https://www.airbnb.com/rooms/241032" "https://www.airbnb.com/rooms/953595" "https://www.airbnb.com/rooms/3308979" "https://www.airbnb.com/rooms/7421966" ...
$ scrape_id : num [1:3818] 20160104002432 20160104002432 20160104002432 20160104002432 20160104002432 ...
$ last_scraped : Date[1:3818], format: "2016-01-04" "2016-01-04" ...
$ name : chr [1:3818] "Stylish Queen Anne Apartment" "Bright & Airy Queen Anne Apartment" "New Modern House-Amazing water view" "Queen Anne Chateau" ...
$ summary : chr [1:3818] NA "Chemically sensitive? We've removed the irritants triggering allergy or asthma attacks, like carpeting, forced "| __truncated__ "New modern house built in 2013. Spectacular sunset/water views and light, rooftop deck and lounge area, hot tu"| __truncated__ "A charming apartment that sits atop Queen Anne hill, northwest facing bay windows with warm afternoon light set"| __truncated__ ...
$ space : chr [1:3818] "Make your self at home in this charming one-bedroom apartment, centrally-located on the west side of Queen Anne"| __truncated__ "Beautiful, hypoallergenic apartment in an extremely safe, quiet and pedestrian-friendly section of Queen Anne. "| __truncated__ "Our house is modern, light and fresh with a warm simple palette accented with barnwood, steel and concrete. Op"| __truncated__ NA ...
$ description : chr [1:3818] "Make your self at home in this charming one-bedroom apartment, centrally-located on the west side of Queen Anne"| __truncated__ "Chemically sensitive? We've removed the irritants triggering allergy or asthma attacks, like carpeting, forced "| __truncated__ "New modern house built in 2013. Spectacular sunset/water views and light, rooftop deck and lounge area, hot tu"| __truncated__ "A charming apartment that sits atop Queen Anne hill, northwest facing bay windows with warm afternoon light set"| __truncated__ ...
$ experiences_offered : chr [1:3818] "none" "none" "none" "none" ...
$ neighborhood_overview : chr [1:3818] NA "Queen Anne is a wonderful, truly functional village. You can walk everywhere... for coffee, for groceries, for"| __truncated__ "Upper Queen Anne is a charming neighborhood full of a mix of beautifully maintained, turn-of-the-century crafts"| __truncated__ NA ...
$ notes : chr [1:3818] NA "What's up with the free pillows? Our home was renovated and restored with health & safety in mind, especially "| __truncated__ "Our house is located just 5 short blocks to Top Pot Doughnuts, Tribunali pizza, Caffe Fiore, Trader Joes and Mo"| __truncated__ NA ...
$ transit : chr [1:3818] NA "Convenient bus stops are just down the block, if you're headed downtown or further afield to explore. Zip cars"| __truncated__ "A bus stop is just 2 blocks away. Easy bus access to all the sites: Lower Queen Anne, Seattle Center, The Spa"| __truncated__ NA ...
$ thumbnail_url : chr [1:3818] NA "https://a0.muscache.com/ac/pictures/14409893/f8e3ed8d_original.jpg?interpolation=lanczos-none&size=small&output"| __truncated__ NA NA ...
$ medium_url : chr [1:3818] NA "https://a0.muscache.com/im/pictures/14409893/f8e3ed8d_original.jpg?aki_policy=medium" NA NA ...
$ picture_url : chr [1:3818] "https://a1.muscache.com/ac/pictures/67560560/cfe47d69_original.jpg?interpolation=lanczos-none&size=large_cover&"| __truncated__ "https://a0.muscache.com/ac/pictures/14409893/f8e3ed8d_original.jpg?interpolation=lanczos-none&size=large_cover&"| __truncated__ "https://a2.muscache.com/ac/pictures/b4324e0f-a41b-4614-85a5-0e58c1983b99.jpg?interpolation=lanczos-none&size=la"| __truncated__ "https://a0.muscache.com/ac/pictures/94146944/6302c803_original.jpg?interpolation=lanczos-none&size=large_cover&"| __truncated__ ...
$ xl_picture_url : chr [1:3818] NA "https://a0.muscache.com/ac/pictures/14409893/f8e3ed8d_original.jpg?interpolation=lanczos-none&size=x_large_cove"| __truncated__ NA NA ...
$ host_id : num [1:3818] 956883 5177328 16708587 9851441 1452570 ...
$ host_url : chr [1:3818] "https://www.airbnb.com/users/show/956883" "https://www.airbnb.com/users/show/5177328" "https://www.airbnb.com/users/show/16708587" "https://www.airbnb.com/users/show/9851441" ...
$ host_name : chr [1:3818] "Maija" "Andrea" "Jill" "Emily" ...
$ host_since : Date[1:3818], format: "2011-08-11" "2013-02-21" ...
$ host_location : chr [1:3818] "Seattle, Washington, United States" "Seattle, Washington, United States" "Seattle, Washington, United States" "Seattle, Washington, United States" ...
$ host_about : chr [1:3818] "I am an artist, interior designer, and run a small landscape business. My life revolves around beauty wherever "| __truncated__ "Living east coast/left coast/overseas. Time is short & it's a big world." "i love living in Seattle. i grew up in the mid-west but the Pacific North West has always felt like home. i a"| __truncated__ NA ...
$ host_response_time : chr [1:3818] "within a few hours" "within an hour" "within a few hours" "N/A" ...
$ host_response_rate : chr [1:3818] "96%" "98%" "67%" "N/A" ...
$ host_acceptance_rate : chr [1:3818] "100%" "100%" "100%" "N/A" ...
$ host_is_superhost : logi [1:3818] FALSE TRUE FALSE FALSE FALSE FALSE ...
$ host_thumbnail_url : chr [1:3818] "https://a0.muscache.com/ac/users/956883/profile_pic/1318103129/original.jpg?interpolation=lanczos-none&crop=w:w"| __truncated__ "https://a0.muscache.com/ac/users/5177328/profile_pic/1361540767/original.jpg?interpolation=lanczos-none&crop=w:"| __truncated__ "https://a1.muscache.com/ac/users/16708587/profile_pic/1428941043/original.jpg?interpolation=lanczos-none&crop=w"| __truncated__ "https://a2.muscache.com/ac/users/9851441/profile_pic/1414045273/original.jpg?interpolation=lanczos-none&crop=w:"| __truncated__ ...
$ host_picture_url : chr [1:3818] "https://a0.muscache.com/ac/users/956883/profile_pic/1318103129/original.jpg?interpolation=lanczos-none&crop=w:w"| __truncated__ "https://a0.muscache.com/ac/users/5177328/profile_pic/1361540767/original.jpg?interpolation=lanczos-none&crop=w:"| __truncated__ "https://a1.muscache.com/ac/users/16708587/profile_pic/1428941043/original.jpg?interpolation=lanczos-none&crop=w"| __truncated__ "https://a2.muscache.com/ac/users/9851441/profile_pic/1414045273/original.jpg?interpolation=lanczos-none&crop=w:"| __truncated__ ...
$ host_neighbourhood : chr [1:3818] "Queen Anne" "Queen Anne" "Queen Anne" "Queen Anne" ...
$ host_listings_count : num [1:3818] 3 6 2 1 2 1 1 5 1 6 ...
$ host_total_listings_count : num [1:3818] 3 6 2 1 2 1 1 5 1 6 ...
$ host_verifications : chr [1:3818] "['email', 'phone', 'reviews', 'kba']" "['email', 'phone', 'facebook', 'linkedin', 'reviews', 'jumio']" "['email', 'phone', 'google', 'reviews', 'jumio']" "['email', 'phone', 'facebook', 'reviews', 'jumio']" ...
$ host_has_profile_pic : logi [1:3818] TRUE TRUE TRUE TRUE TRUE TRUE ...
$ host_identity_verified : logi [1:3818] TRUE TRUE TRUE TRUE TRUE TRUE ...
$ street : chr [1:3818] "Gilman Dr W, Seattle, WA 98119, United States" "7th Avenue West, Seattle, WA 98119, United States" "West Lee Street, Seattle, WA 98119, United States" "8th Avenue West, Seattle, WA 98119, United States" ...
$ neighbourhood : chr [1:3818] "Queen Anne" "Queen Anne" "Queen Anne" "Queen Anne" ...
$ neighbourhood_cleansed : chr [1:3818] "West Queen Anne" "West Queen Anne" "West Queen Anne" "West Queen Anne" ...
$ neighbourhood_group_cleansed : chr [1:3818] "Queen Anne" "Queen Anne" "Queen Anne" "Queen Anne" ...
$ city : chr [1:3818] "Seattle" "Seattle" "Seattle" "Seattle" ...
$ state : chr [1:3818] "WA" "WA" "WA" "WA" ...
$ zipcode : num [1:3818] 98119 98119 98119 98119 98119 ...
$ market : chr [1:3818] "Seattle" "Seattle" "Seattle" "Seattle" ...
$ smart_location : chr [1:3818] "Seattle, WA" "Seattle, WA" "Seattle, WA" "Seattle, WA" ...
$ country_code : chr [1:3818] "US" "US" "US" "US" ...
$ country : chr [1:3818] "United States" "United States" "United States" "United States" ...
$ latitude : num [1:3818] 47,6 47,6 47,6 47,6 47,6 ...
$ longitude : num [1:3818] -122 -122 -122 -122 -122 ...
$ is_location_exact : logi [1:3818] TRUE TRUE TRUE TRUE TRUE TRUE ...
$ property_type : chr [1:3818] "Apartment" "Apartment" "House" "Apartment" ...
$ room_type : chr [1:3818] "Entire home/apt" "Entire home/apt" "Entire home/apt" "Entire home/apt" ...
$ accommodates : num [1:3818] 4 4 11 3 6 2 2 2 2 4 ...
$ bathrooms : num [1:3818] 1 1 4,5 1 2 1 1 1 1 1 ...
$ bedrooms : num [1:3818] 1 1 5 0 3 1 1 1 1 1 ...
$ beds : num [1:3818] 1 1 7 2 3 1 1 1 1 1 ...
$ bed_type : chr [1:3818] "Real Bed" "Real Bed" "Real Bed" "Real Bed" ...
$ amenities : chr [1:3818] "{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"Air Conditioning\",Kitchen,Heating,\"Family/Kid Friendly\",Washer,Dryer}" "{TV,Internet,\"Wireless Internet\",Kitchen,\"Free Parking on Premises\",\"Buzzer/Wireless Intercom\",Heating,\""| __truncated__ "{TV,\"Cable TV\",Internet,\"Wireless Internet\",\"Air Conditioning\",Kitchen,\"Free Parking on Premises\",\"Pet"| __truncated__ "{Internet,\"Wireless Internet\",Kitchen,\"Indoor Fireplace\",Heating,\"Family/Kid Friendly\",Washer,Dryer,\"Smo"| __truncated__ ...
$ square_feet : num [1:3818] NA NA NA NA NA NA NA NA NA NA ...
$ price : chr [1:3818] "$85.00" "$150.00" "$975.00" "$100.00" ...
$ weekly_price : chr [1:3818] NA "$1,000.00" NA "$650.00" ...
$ monthly_price : chr [1:3818] NA "$3,000.00" NA "$2,300.00" ...
$ security_deposit : chr [1:3818] NA "$100.00" "$1,000.00" NA ...
$ cleaning_fee : chr [1:3818] NA "$40.00" "$300.00" NA ...
$ guests_included : num [1:3818] 2 1 10 1 6 1 1 1 1 1 ...
$ extra_people : chr [1:3818] "$5.00" "$0.00" "$25.00" "$0.00" ...
$ minimum_nights : num [1:3818] 1 2 4 1 1 1 3 2 3 2 ...
$ maximum_nights : num [1:3818] 365 90 30 1125 1125 ...
$ calendar_updated : chr [1:3818] "4 weeks ago" "today" "5 weeks ago" "6 months ago" ...
$ has_availability : logi [1:3818] TRUE TRUE TRUE TRUE TRUE TRUE ...
$ availability_30 : num [1:3818] 14 13 1 0 30 0 20 22 6 6 ...
$ availability_60 : num [1:3818] 41 13 6 0 60 0 49 42 36 19 ...
$ availability_90 : num [1:3818] 71 16 17 0 90 27 71 42 66 49 ...
$ availability_365 : num [1:3818] 346 291 220 143 365 302 346 100 341 324 ...
$ calendar_last_scraped : Date[1:3818], format: "2016-01-04" "2016-01-04" ...
$ number_of_reviews : num [1:3818] 207 43 20 0 38 17 58 173 8 32 ...
$ first_review : Date[1:3818], format: "2011-11-01" "2013-08-19" ...
$ last_review : Date[1:3818], format: "2016-01-02" "2015-12-29" ...
$ review_scores_rating : num [1:3818] 95 96 97 NA 92 95 99 97 97 97 ...
$ review_scores_accuracy : num [1:3818] 10 10 10 NA 9 10 10 10 10 10 ...
$ review_scores_cleanliness : num [1:3818] 10 10 10 NA 9 10 10 10 9 10 ...
$ review_scores_checkin : num [1:3818] 10 10 10 NA 10 10 10 10 10 10 ...
$ review_scores_communication : num [1:3818] 10 10 10 NA 10 10 10 10 9 10 ...
$ review_scores_location : num [1:3818] 9 10 10 NA 9 10 10 9 10 10 ...
$ review_scores_value : num [1:3818] 10 10 10 NA 9 10 10 10 10 9 ...
$ requires_license : logi [1:3818] FALSE FALSE FALSE FALSE FALSE FALSE ...
$ license : logi [1:3818] NA NA NA NA NA NA ...
$ jurisdiction_names : chr [1:3818] "WASHINGTON" "WASHINGTON" "WASHINGTON" "WASHINGTON" ...
$ instant_bookable : logi [1:3818] FALSE FALSE FALSE FALSE FALSE FALSE ...
$ cancellation_policy : chr [1:3818] "moderate" "strict" "strict" "flexible" ...
$ require_guest_profile_picture : logi [1:3818] FALSE TRUE FALSE FALSE FALSE FALSE ...
$ require_guest_phone_verification: logi [1:3818] FALSE TRUE FALSE FALSE FALSE FALSE ...
$ calculated_host_listings_count : num [1:3818] 2 6 2 1 1 1 1 5 1 6 ...
$ reviews_per_month : num [1:3818] 4,07 1,48 1,15 NA 0,89 2,45 2,46 4,73 1,22 1,55 ...
- attr(*, "spec")=
.. cols(
.. id = col_double(),
.. listing_url = col_character(),
.. scrape_id = col_double(),
.. last_scraped = col_date(format = ""),
.. name = col_character(),
.. summary = col_character(),
.. space = col_character(),
.. description = col_character(),
.. experiences_offered = col_character(),
.. neighborhood_overview = col_character(),
.. notes = col_character(),
.. transit = col_character(),
.. thumbnail_url = col_character(),
.. medium_url = col_character(),
.. picture_url = col_character(),
.. xl_picture_url = col_character(),
.. host_id = col_double(),
.. host_url = col_character(),
.. host_name = col_character(),
.. host_since = col_date(format = ""),
.. host_location = col_character(),
.. host_about = col_character(),
.. host_response_time = col_character(),
.. host_response_rate = col_character(),
.. host_acceptance_rate = col_character(),
.. host_is_superhost = col_logical(),
.. host_thumbnail_url = col_character(),
.. host_picture_url = col_character(),
.. host_neighbourhood = col_character(),
.. host_listings_count = col_double(),
.. host_total_listings_count = col_double(),
.. host_verifications = col_character(),
.. host_has_profile_pic = col_logical(),
.. host_identity_verified = col_logical(),
.. street = col_character(),
.. neighbourhood = col_character(),
.. neighbourhood_cleansed = col_character(),
.. neighbourhood_group_cleansed = col_character(),
.. city = col_character(),
.. state = col_character(),
.. zipcode = col_double(),
.. market = col_character(),
.. smart_location = col_character(),
.. country_code = col_character(),
.. country = col_character(),
.. latitude = col_double(),
.. longitude = col_double(),
.. is_location_exact = col_logical(),
.. property_type = col_character(),
.. room_type = col_character(),
.. accommodates = col_double(),
.. bathrooms = col_double(),
.. bedrooms = col_double(),
.. beds = col_double(),
.. bed_type = col_character(),
.. amenities = col_character(),
.. square_feet = col_double(),
.. price = col_character(),
.. weekly_price = col_character(),
.. monthly_price = col_character(),
.. security_deposit = col_character(),
.. cleaning_fee = col_character(),
.. guests_included = col_double(),
.. extra_people = col_character(),
.. minimum_nights = col_double(),
.. maximum_nights = col_double(),
.. calendar_updated = col_character(),
.. has_availability = col_logical(),
.. availability_30 = col_double(),
.. availability_60 = col_double(),
.. availability_90 = col_double(),
.. availability_365 = col_double(),
.. calendar_last_scraped = col_date(format = ""),
.. number_of_reviews = col_double(),
.. first_review = col_date(format = ""),
.. last_review = col_date(format = ""),
.. review_scores_rating = col_double(),
.. review_scores_accuracy = col_double(),
.. review_scores_cleanliness = col_double(),
.. review_scores_checkin = col_double(),
.. review_scores_communication = col_double(),
.. review_scores_location = col_double(),
.. review_scores_value = col_double(),
.. requires_license = col_logical(),
.. license = col_logical(),
.. jurisdiction_names = col_character(),
.. instant_bookable = col_logical(),
.. cancellation_policy = col_character(),
.. require_guest_profile_picture = col_logical(),
.. require_guest_phone_verification = col_logical(),
.. calculated_host_listings_count = col_double(),
.. reviews_per_month = col_double()
.. )
- attr(*, "problems")=<externalptr>